package ssm.dao;

import org.apache.ibatis.annotations.Select;
import ssm.domain.Traveller;

import java.util.List;

public interface ITravellerDao {

    /*先根据order的id,查询中间表，然后查询到traveller中的内容*/
    @Select("select * from traveller where id in (select travellerId from order_traveller where orderId = #{ordersId})")
    public List<Traveller> findByOrdersId(String ordersId) throws Exception ;
}
